How to: Add a date or time field in a table.
Solution:
In the Table Design view, insert the field, and type a field name. Then select 'Date/Time' from the drop-down list in the 'Data Type' column.
1) If the Database window is not active, activate the Database window.
2) Go to the Table Design view:
a) Click the 'Table' tab in the Database window.
Tables tab
b) Select the desired table from the list.
c) Click 'Design'.
3) Do one of the following to add a field to the table:
a) To add the field to the end of the table, click in the first blank row.
b) To insert a field within the table:
1] Click in the row above which the field is to be added.
2] Select the 'Insert' menu and select 'Field'. (The row appears above the selected row.)
4) Type a name for the field in the 'Field Name' column.
5) Click in the 'Data Type' column. (A down arrow appears.)
6) Click on the arrow in the 'Data Type' column. (A drop-down list appears.)
7) Select 'Date/Time' from the 'Data Type' drop-down list.
Date/Time
8) To set a format for the date or time field:
a) Move to the 'Field Properties' section.
Field Properties section
b) Click the 'General' tab.
c) Click in the 'Format' property box. (A down arrow appears.)
d) Click on the arrow in the 'Format' property box. (A drop-down list appears.)
e) Select a time format from the 'Format' drop-down list.
9) (Optional) Set other field properties in the 'Field Properties' section for the added field.
Field Properties section
10) Select the 'File' menu and select 'Save'.
11) Select the 'File' menu and select 'Close' when finished making changes in the Table Design window.
